<?php include('CSRE_login_control.php') ?>

<?php require_once('Connections/CSRE_Connection.php'); ?>
<?php

mysql_select_db($database_CSRE_Connection, $CSRE_Connection);
$query_demandedinformation_text = "SELECT `value` FROM csre_text WHERE name = 'demandedinformation'";
$demandedinformation_text = mysql_query($query_demandedinformation_text, $CSRE_Connection) or die(mysql_error());
$row_demandedinformation_text = mysql_fetch_assoc($demandedinformation_text);
$totalRows_demandedinformation_text = mysql_num_rows($demandedinformation_text);
?>

<?php
$colname_medipoints = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_medipoints = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_CSRE_Connection, $CSRE_Connection);
$query_medipoints = sprintf("SELECT medipoints FROM csre_client WHERE `user` = '%s'", $colname_medipoints);
$medipoints = mysql_query($query_medipoints, $CSRE_Connection) or die(mysql_error());
$row_medipoints = mysql_fetch_assoc($medipoints);
$totalRows_medipoints = mysql_num_rows($medipoints);
?>

<?php include('CSRE_header.php'); ?>
	
	<script src="accordion/accordian.pack.js" language="javascript" type="text/javascript">
	</script>
	
	<div align="center">
		<span style="background-color:#FFFFFF;">
			<table class="base_table">
				<tr>
				<td valign="top" width="200">
					<?php include('CSRE_left_menu.php'); ?>
				</td>
				
				<td style="background-image:url('images/divider.gif'); background-repeat:repeat-y;"></td>
				
				<td valign="top">
									
					<table width="100%" style="text-align:left">
							<tr valign="top">
								<td class="title_csre">
									<?php echo $messages['csre']['membreducsre.text']; ?>
								</td>
							</tr>
							<tr>
								<td height="5">
								</td>
							</tr>
							<tr><td height="10"></td></tr>
							<tr>
								<td class="text" style="color:#6CA966; font-size:16px;"><strong>Votre MediPoints: <?php echo $row_medipoints['medipoints']; ?> </strong></td>
							</tr>
							<tr><td height="10"></td></tr>							
							<tr>
								<td class="text"><?php echo $row_demandedinformation_text['value']; ?> </td>
							</tr>
				  </table>
					
				  </td>
				</tr>
			</table>
		</span>
	</div>

<?php include('CSRE_footer.php'); ?>
<?php

mysql_free_result($demandedinformation_text);

?>